![Zendesk Explore For Query of Solved Tickets and Full Resolution in a Month](https://devio2023-media.developers.io/wp-content/uploads/2020/04/zendesk-logo-core-kale-2019.png)
Zendesk Explore For Query of Solved Tickets and Full Resolution in a Month
Zendesk
A cloud-based help desk management solution offering a customer service portal, knowledge base, and online communities to be built. The solution offers a front-end portal, live chat features that are customizable and can be integrated with applications like salesforce and google analytics.
Zendesk Explore
A reporting tool that enhances business, can identify and optimize workflows to help teams and agents and can understand the trends and gain insights where improvements can have an immediate impact. It can be used to know operational efficiency and customer satisfaction. Recent industry research states that about 46% of the industry uses CSAT to measure company success. It has powerful inbuilt reports to view and analyze key information regarding customers and support resources. Use explore to build your own reports.
Query
Describe the graphs and reports that are created, here we ask a question and the result can be visualized. In a spreadsheet way, it would mean calculating rows, columns, etc, and the display is finally in form of graphs or tables. It is a combination of metric and Attributes
1) Metric
A numeric value that you want to measure. They are quantifiable. A simple metric could be the number of solved tickets.
2) Attribute
It is used to slice and break down metrics. They are non-quantifiable. A simple attribute could be the assignee name.
Demo
Click on new query
Next click on support in zendesk product and tickets in dataset type finally click on new query.
Click on Add in metric -> tickets -> solved tickets -> COUNT -> click apply
Attribute to break down the query, ticket solved in a month
Click on Add in rows -> In search bar type solved month and click it -> click apply
click the attribute -> select month (At the time of writing this blog it is September so I will be clicking on September)
2nd Metric Resolution Time
Click Add on metric button -> In search bar type full-resolution business hours (hrs) -> click apply
click on 2nd metric and click average to aggregate data